User Profile

Kasafkhan

Copper Contributor

Joined Jun 12, 2022

5 Posts

View All Badges

User Widgets

Recent Discussions

Find missing dates
Good day to all members, I am struggling with dates. I attached a file for example. I need to find the missing dates between the dates & report them, Anyone can please suggest me a way to do it?
Aug 06, 2022 Place Excel
excel
16KViews
0likes
3Comments
Re: Excel Formula
Thank you, sir.it works very well. but can you please suggest, if I want to remove that default date "30-dec-1904" from a blank cell, where a date is not available.
Jun 12, 2022 Place Excel
1.5KViews
0likes
1Comment
Re: Excel Formula
Thank you for the response. But there is more in a category. Ex. I want "NA" for Officer & Foreman, then Edate formula on Staff & FO. Please suggest me formula for this.
Jun 12, 2022 Place Excel
1.5KViews
0likes
3Comments
Re: Excel Formula
Thank you so much for such a quick response. I was stuck & exhausted on this. you relived me.👌👍
Jun 12, 2022 Place Excel
1.5KViews
0likes
0Comments
Excel Formula
Greetings of the day, Example. I have a category in data like officer & staff. in which I want to show the training due date by using the Edate formula. but where an officer is there, there should be shows "NA" & if there is staff in the category I want to run the Edate formula. Please suggest ways to to do it.
Solved
Jun 12, 2022 Place Excel
excel
1.7KViews
0likes
6Comments

Recent Blog Articles

No content to show