IF Formula

J

jgp19

New Member
Joined
Jun 16, 2024
Messages
6
Office Version
  1. 365
Platform
  1. Windows
Can anyone help to write to if formula for below scenario?

employee joining date having less than date 01-06-2024 in a cell then give value of 30 days having in a cell and if employee joining date having equal or higher date that is 30-06-2024, then give value subtracting 30-06-2024-02-06-2024.

Please help.

1718559939934.png
 
Sort by date Sort by votes

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
You must log in or register to reply here.

Similar threads

K
  • Solved
Evaluate date range and return the corresponding month and year
Replies
1
Views
241
Scott Huish
Scott Huish
F
  • Question Question
VBA Macro Issue: Replacing Simple Formula with Complex Formula Causes Error
Replies
2
Views
161
flashgordie
F
D
  • Question Question
Formula help needed for working with days and times.
Replies
0
Views
473
dshtesy
D
S
  • Solved
Hyperlink point to specific cell in another sheet
Replies
2
Views
257
Schturman
S
B
  • Solved
timestamp listing to show more than >19hrs away per day?
Replies
9
Views
198
Boboka
B

Forum statistics

Threads
1,225,626
Messages
6,186,087
Members
453,336
Latest member
Excelnoob223

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top