Hi and Hello there
Need you support on how to apply formula to get exact dates.
When I try the functions, Day, Edate, i get date less one day.
Hi and Hello there
Need you support on how to apply formula to get exact dates.
When I try the functions, Day, Edate, i get date less one day.
It would help if you quoted the formula you are trying to use, but why not add +1 to the end of your existing formula?
Hope this helps.
Pete
Ostensibly just add +1 to the formula you are using.
However, I am not clear about what you are trying to achieve. You will need to explain with examples.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
When I drag the formula, I get 1 in all rows
You might have to change your formula along the lines of:
=IF(date_cell="","",your_existing_formula +1)
Hope this helps.
Pete
Please see file attached
Put this formula in G7:
=IF(OR(E7="",F7=""),"",F7-E7+1)
then copy down.
Hope this helps.
Pete
Thank you Pete.
It did work.
Formula:Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks