Oct 31 2021 11:33 AM
Good Afternoon! I'm aging sales data but need it to stop aging when an item is sold. I have start date(G5) sale date (H5) and days aged as of today columns. This is my formula but it's not working. I keep getting an excel error. I'm trying to tell it if there is no date in H5, use today's date. Each formula works independently. Any ideas?
=DATEDIF(G5,H5,"d"),IF(H5<1(TODAY()-G5,0))
Oct 31 2021 11:44 AM
SolutionThere are other ways to do it, but I will keep your approach as adjusted below
=IF(H5<1,TODAY()-G5,DATEDIF(G5,H5,"d"))
Oct 31 2021 11:44 AM
SolutionThere are other ways to do it, but I will keep your approach as adjusted below
=IF(H5<1,TODAY()-G5,DATEDIF(G5,H5,"d"))