Forum Discussion
Solved
Help with date math please
I'm using this formula to calculate the number of days between 2 dates and return blank if the one date hasn't been filled in yet: =IF(AS32<>"",AS32-AS39,"") Where: AS32 is a manually-entere...
What you believe to be March 20 is in fact March 16, custom formatted to be displayed as March 20. What did you have in mind with that custom format in AS39?
What you believe to be March 20 is in fact March 16, custom formatted to be displayed as March 20. What did you have in mind with that custom format in AS39?
Thank you for looking at this and replying. So the top date in row 2 is (as you can see) just the month and year. Actually I think you pointed me in the right direction. I changed the dates to 3/20/2026 and was able to drag to the right to increment. This also fixed the days math!!!
Thanks 🙂