cm0002@lemmy.world to Programmer Humor@programming.dev · 7 months agoExcel logiclemmy.mlexternal-linkmessage-square129linkfedilinkarrow-up11.31Karrow-down1122cross-posted to: programmerhumor@lemmy.ml
arrow-up11.19Karrow-down1external-linkExcel logiclemmy.mlcm0002@lemmy.world to Programmer Humor@programming.dev · 7 months agomessage-square129linkfedilinkcross-posted to: programmerhumor@lemmy.ml
minus-squarepsud@aussie.zonelinkfedilinkEnglisharrow-up2·7 months agoYou can make a date from a datetime in cell A1 with =Date(year(A1), month(A1), day(A1))
You can make a date from a datetime in cell A1 with
=Date(year(A1), month(A1), day(A1))